﻿CREATE TABLE [dbo].[MsgChannel] (
    [Id]             BIGINT            IDENTITY (1, 1) NOT NULL,
    [BkMemberId]     BIGINT            CONSTRAINT [DF_MsgChannel_BkMemberId] DEFAULT -1 NOT NULL,
    [WxUserId]       BIGINT  CONSTRAINT [DF_MsgChannel_WxUserId] DEFAULT -1 NOT NULL,
    [ChannelName]    NVARCHAR(100)  NOT NULL,
    [KeyInChannel]   NVARCHAR(500)  NOT NULL,
    [ValueInChannel] VARCHAR (2000) NOT NULL,
    [CreatTime]      DATETIME       NOT NULL,
    [UpdateTime]     DATETIME       NOT NULL,
    CONSTRAINT [PK_MsgChannel] PRIMARY KEY CLUSTERED ([Id] ASC)
);




GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'数据更新时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgChannel', @level2type = N'COLUMN', @level2name = N'UpdateTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'数据生成时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgChannel', @level2type = N'COLUMN', @level2name = N'CreatTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'推送时需要传入的信息', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgChannel', @level2type = N'COLUMN', @level2name = N'ValueInChannel';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'渠道内的唯一标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgChannel', @level2type = N'COLUMN', @level2name = N'KeyInChannel';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'推送渠道名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgChannel', @level2type = N'COLUMN', @level2name = N'ChannelName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户Id', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgChannel', @level2type = N'COLUMN', @level2name = N'BkMemberId';

